﻿using System;
using System.Data;
using System.Collections.Generic;

using Com.Framework.Data;
using Com.Library.DB;

namespace Com.Library.DB.Store
{
	internal class StoreGetInfo : DBDataReader<DataEntity, StoreEntity>
	{
		public StoreGetInfo()
			: base(new ConnectionString(), "TSP_Store_GetInfo")
		{
		}

		protected override void ParameterInitialize()
		{
			AddParameter("n4StoreNo", SqlDbType.Int, 4, SqlDataInOut.InputOutput);
			AddParameter("strUserID", SqlDbType.VarChar, 50, SqlDataInOut.InputOutput);
			AddParameter("IsActive", SqlDbType.Char, 1, SqlDataInOut.Output);
			AddParameter("strStoreName", SqlDbType.NVarChar, 200, SqlDataInOut.Output);
			AddParameter("strCompanyNo", SqlDbType.VarChar, 20, SqlDataInOut.Output);
			AddParameter("strPhone", SqlDbType.VarChar, 30, SqlDataInOut.Output);
			AddParameter("strPost", SqlDbType.VarChar, 10, SqlDataInOut.Output);
			AddParameter("strAddress", SqlDbType.NVarChar, 400, SqlDataInOut.Output);
			AddParameter("strCityName", SqlDbType.NVarChar, 20, SqlDataInOut.Output);
			AddParameter("IsTakeout", SqlDbType.Char, 1, SqlDataInOut.Output);
			AddParameter("strTakeout", SqlDbType.NVarChar, 100, SqlDataInOut.Output);
			AddParameter("IsParking", SqlDbType.Char, 1, SqlDataInOut.Output);
			AddParameter("strParking", SqlDbType.NVarChar, 100, SqlDataInOut.Output);
			AddParameter("strStoreSize", SqlDbType.VarChar, 50, SqlDataInOut.Output);
			AddParameter("strOpenDate", SqlDbType.VarChar, 20, SqlDataInOut.Output);
			AddParameter("strOpenTime", SqlDbType.VarChar, 50, SqlDataInOut.Output);
			AddParameter("strPointX", SqlDbType.VarChar, 30, SqlDataInOut.Output);
			AddParameter("strPointY", SqlDbType.VarChar, 30, SqlDataInOut.Output);
			AddParameter("strDescription", SqlDbType.NVarChar, 4000, SqlDataInOut.Output);
			AddParameter("dtCreateDate", SqlDbType.DateTime, 8, SqlDataInOut.Output);
			AddParameter("strManagerName", SqlDbType.NVarChar, 100, SqlDataInOut.Output);
		}
	}
}